import datetime
from docx import Document
import pandas as pd
#从doc_file尽调问卷word文档中读取数据
#必须确保尽调问卷按要求填写完整，否则可能报错!
def get_manager_info(doc_file) -> dict:
        
        #读取doc_file文档
        doc = Document(doc_file)
        
        #读取doc_file文档中的所有表格
        tables = doc.tables
        
        #读取table_1公司概况信息表
        tb = tables[0]
        
        #获取公司名称，位于第1行第2列的单元格
        company_name = tb.cell(0,1).text
        
        #获取法定代表人，位于第1行第4列的单元格
        company_represent = tb.cell(0,3).text

        #获取注册资本，位于第2行第2列的单元格（注意：数值数据有可能加入了千位分隔符，转换为float类型）
        registered_capital = float(tb.cell(1,1).text.replace(",",""))

        #获取实缴资本，位于第2行第4列的单元格（注意：数值数据有可能加入了千位分隔符，转换为float类型）
        contributed_capital = float(tb.cell(1,3).text.replace(",",""))

        #获取成立日期，位于第3行第2列的单元格
        establish_date = tb.cell(2,1).text.replace('年','-').replace('月','-').replace('日','').replace('号','')

        #获取基协登记日期，位于第3行第4列的单元格
        registered_date = tb.cell(2,3).text.replace('年','-').replace('月','-').replace('日','').replace('号','')
        
        #计算基协登记年限
        registered_years = (datetime.date.today()-pd.to_datetime(registered_date).date()).days/365

        #获取是否具有投顾资格，位于第4行第2列的单元格
        advisor_qualification = tb.cell(3,1).text

        #获取是否协会会员，位于第4行第4列的单元格
        is_member = tb.cell(3,3).text

        #获取统一信用代码，位于第5行第2列的单元格
        credit_id = tb.cell(4,1).text

        #获取基协登记编号，位于第5行第4列的单元格
        registered_id = tb.cell(4,3).text

        #获取注册地址，位于第6行第2列的单元格
        registered_address = tb.cell(5,1).text

        #获取办公地址，位于第6行第4列的单元格
        office_address = tb.cell(5,3).text

        #获取总人数，位于第7行第2列的单元格，转换为int数据类型
        staff_number = int(tb.cell(6,1).text)

        #获取投研人数，位于第7行第4列的单元格，转换为int数据类型
        research_team_number = int(tb.cell(6,3).text)
        
        #投研团队人数比例
        research_team_ratio = research_team_number / staff_number
        
        #读取table_3财务数据表
        tb = tables[2]   
        
        #获取最近一个会计年度的年份
        last_year = tb.cell(0,1).text.strip("年度")
        
        #根据评价标准，仅需获取近2年主营业务收入数据（注意：数值数据有可能加入了千位分隔符）
        main_income = [float(tb.cell(1,1).text.replace(",","")),float(tb.cell(1,2).text.replace(",",""))]
        
        #根据评价标准，仅需获取近2年净利润数据（注意：数值数据有可能加入了千位分隔符）
        net_profit = [float(tb.cell(2,1).text.replace(",","")),float(tb.cell(2,2).text.replace(",",""))]
        
        #根据评价标准，仅需获取最近一个会计年度末总资产数据（注意：数值数据有可能加入了千位分隔符）
        last_total_assets = float(tb.cell(4,1).text.replace(",",""))
        
        #根据评价标准，仅需获取最近一个会计年度末负债数据（注意：数值数据有可能加入了千位分隔符）
        last_liabilities = float(tb.cell(5,1).text.replace(",",""))
        
        #计算最近一个会计年度末资产负债率
        debt_ratio = last_liabilities/last_total_assets
        
        #最近一个会计年度主营业务收入
        last_main_income = main_income[0]
        
        #计算最近两个会计年度平均主营业务收入
        last_2_mean_main_income = (main_income[0] + main_income[1])/2
        
        #最近一个会计年度净利润
        last_net_profit = net_profit[0]
        
        #计算最近两个会计年度平均净利润
        last_2_mean_net_profit = (net_profit[0] + net_profit[1])/2
        
        #读取table_4治理结构信息表
        tb = tables[3]
        
        #近3年公司实际控制人、董事长及总经理是否发生变更
        critical_changes_in_last_3_years = tb.cell(1,1).text
        if critical_changes_in_last_3_years in ["否","无"]:
            #如为否，则生成对应说明文字，方便生成评估报告用
            critical_changes_in_last_3_years_remarks = "近3年内，公司实际控制人、董事长及总经理未发生变更"      
        else:
            #如为是，则取表格中对应填写的说明文字
            critical_changes_in_last_3_years_remarks = tb.cell(1,2).text
            
        
        #近2年内，公司投资总监、合规风控负责人、核心投资经理或策略研究人员是否发生离职
        core_staff_changes_in_last_2_years = tb.cell(2,1).text
        if core_staff_changes_in_last_2_years in ["否","无"]:
            #如为否，则生成对应说明文字，方便生成评估报告用
            core_staff_changes_in_last_2_years_remarks = "近2年内，公司投资总监、合规风控负责人、核心投资经理或策略研究人员\
                                                         未发生离职"      
        else:
            #如为是，则取表格中对应填写的说明文字，删除文末句号（报告模板文件中已存在句号结尾）
            core_staff_changes_in_last_2_years_remarks = tb.cell(2,2).text.strip("。")

        #核心投研人员持股比例，去掉百分号后转换为对应的float数据类型
        core_research_shareholding_ratio = float(tb.cell(3,1).text.strip("%"))/100
        #读取核心投研人员持股比例对应的说明文字，删除文末句号（报告模板文件中已存在句号结尾）
        core_research_shareholding_ratio_remarks = tb.cell(3,2).text.strip("。")
        
        #实际控制人
        actual_controller = tb.cell(4,1).text
        #读取实际控制人对应的说明文字，删除文末句号（报告模板文件中已存在句号结尾）
        actual_controller_remarks = tb.cell(4,2).text.strip("。")
        
        #实际控制人持股比例，去掉百分号后转换为对应的float数据类型，并保留4位小数
        actual_controller_shareholding_ratio = float(tb.cell(5,1).text.strip("%"))/100
        #读取实际控制人持股比例对应的说明文字，删除文末句号（报告模板文件中已存在句号结尾）
        actual_controller_shareholding_ratio_remarks = tb.cell(5,2).text.strip("。")
        
        #是否有员工持股做激励
        employee_share_motivation = tb.cell(6,1).text
        if employee_share_motivation in ["否","无"]:
            #如为否，则生成对应说明文字，方便生成评估报告用
            employee_share_motivation_remarks = '公司暂未实施员工持股激励'
        else:
            #如为是，则取表格中对应填写的说明文字，删除文末句号（报告模板文件中已存在句号结尾）
            employee_share_motivation_remarks = tb.cell(6,2).text.strip("。")
        
        #公司是否存在夫妻关系、兄弟关系或其他直系亲属关系的自然人股东合计控制80%（含）以上股权的情况
        shareholders_relationship = tb.cell(7,1).text
        if shareholders_relationship in ["否","无"]:
            #如为否，则生成对应说明文字，方便生成评估报告用
            shareholders_relationship_remarks = '公司不存在夫妻关系、兄弟关系或其他直系亲属关系的自然人股东合计控制80%（含）以上\
                                                 股权的情况'
        else:
            #如为是，则取表格中对应填写的说明文字，删除文末句号（报告模板文件中已存在句号结尾）
            shareholders_relationship_remarks = tb.cell(7,2).text.strip("。")
        
        #读取table_5主要高管人员信息表，并保存到DataFrame：senior_manager
        tb = tables[4]
        df = []
        for i in range(1,len(tb.rows)):#首行不取，作为columns            
            df.append([tb.cell(i,0).text,tb.cell(i,1).text,tb.cell(i,2).text,tb.cell(i,3).text])  
        senior_manager = pd.DataFrame(df,columns=[tb.cell(0,0).text,tb.cell(0,1).text,tb.cell(0,2).text,tb.cell(0,3).text])
        
        #读取table_6部门架构信息表
        tb = tables[5]
        
        #部门数量
        department_number = len(tb.rows)-1
        
        #将部门架构信息表保存到DataFrame：department_structure
        df = []
        for i in range(1,len(tb.rows)):#首行不取，作为columns            
            df.append([tb.cell(i,0).text,tb.cell(i,1).text,tb.cell(i,2).text,tb.cell(i,3).text])              
        department_structure = pd.DataFrame(df,columns=[tb.cell(0,0).text,tb.cell(0,1).text,tb.cell(0,2).text,tb.cell(0,3).text])
        
        #计算部门负责人重叠次数
        dp = department_structure.groupby(['负责人']).size()
        overlap_leader = (dp-1).sum()
        
        #添加部门负责人重叠的具体说明
        if overlap_leader > 0:
            overlap_leader_remarks = ''        
            for i in range(len(dp[dp>1])):
                if i > 0:
                    overlap_leader_remarks = overlap_leader_remarks+','
                overlap_leader_remarks = overlap_leader_remarks + dp[dp>1].index[i]+'担任'+str(dp[dp>1][i])+'个部门负责人'
        else:
            overlap_leader_remarks = '各部门负责人无重叠情况'
            
        #读取table_7机构合作与获奖情况表
        tb = tables[6]
        
        #管理人所获重要奖项及具体说明
        company_important_awards = int(tb.cell(1,1).text)
        company_important_awards_remarks = tb.cell(1,2).text.strip("。")
        
        #核心投资经理获奖记录及具体说明
        manager_important_awards = int(tb.cell(2,1).text)
        manager_important_awards_remarks = tb.cell(2,2).text.strip("。")
        
        #代销合作金融机构数量及具体说明
        cooperate_financial_institutions_number = int(tb.cell(3,1).text)
        cooperate_financial_institutions_number_remarks = tb.cell(3,2).text.strip("。")
        
        #代销规模（亿元）及具体说明
        agent_sales_scale = float(tb.cell(4,1).text)
        agent_sales_scale_remarks = tb.cell(4,2).text.strip("。")
        
        #金融机构直投家数及具体说明
        financial_institutions_invest_scale = float(tb.cell(5,1).text)
        financial_institutions_invest_scale_remarks = tb.cell(5,2).text.strip("。")
        
        #读取table_8管理规模表
        tb = tables[7]
        
        #自营规模（亿元）
        self_invest_scale = float(tb.cell(1,0).text)
        
        #直销规模（亿元）
        self_sales_scale = float(tb.cell(1,1).text)
        
        #代销规模（亿元）
        total_agent_sales_scale = float(tb.cell(1,2).text)
        
        #合计规模（亿元）
        total_manage_scale = float(tb.cell(1,3).text)
        
        #读取table_9产品管理情况表
        tb = tables[8]
        
        #将产品管理信息表保存到DataFrame：product_manage_info
        df = []
        for i in range(1,len(tb.rows)):#首行不取
            if i< len(tb.rows)-1:
                df.append([tb.cell(i,0).text,int(tb.cell(i,1).text),float(tb.cell(i,2).text),tb.cell(i,3).text])  
            else:#最后一行为合计数
                #总产品数量
                total_product_number = int(tb.cell(i,1).text)
                
        product_manage_info = pd.DataFrame(df,columns=['strategy','number','scale','represent'])
        
        #读取table_10投研团队信息表
        tb = tables[9]
        
        #将投研团队信息表保存到DataFrame：research_team_info
        df = []
        for i in range(1,len(tb.rows)):#首行不取，作为columns
            df.append([tb.cell(i,0).text,tb.cell(i,1).text,tb.cell(i,2).text,tb.cell(i,3).text,\
                       float(tb.cell(i,4).text),tb.cell(i,5).text,float(tb.cell(i,6).text.strip("%"))/100,\
                       int(tb.cell(i,7).text)])  
            
        research_team_info = pd.DataFrame(df,columns=['name','position','birthday','education','working_years','resume',\
                                                      'shareholding_ratio','backgroud_flag'])
        #投研人员从业年限列表
        research_team_experience = research_team_info['working_years'].tolist()
        #投研人员从业背景标识列表
        research_team_background = research_team_info['backgroud_flag'].tolist() 
 
        #将以上数据保存到字典manager_data
        manager_info = {'company_name':company_name,'registered_capital':registered_capital,'company_represent':company_represent,\
                        'contributed_capital':contributed_capital,'establish_date':establish_date,\
                        'registered_date':registered_date,'registered_years':registered_years,\
                        'advisor_qualification':advisor_qualification,'is_member':is_member,'credit_id':credit_id,\
                        'registered_id':registered_id,'staff_number':staff_number,'research_team_number':research_team_number,\
                        'research_team_ratio':research_team_ratio,\
                        'registered_address':registered_address,'office_address':office_address,'last_main_income':last_main_income,\
                        'last_2_mean_main_income':last_2_mean_main_income,'last_net_profit':last_net_profit,\
                        'last_2_mean_net_profit':last_2_mean_net_profit,'last_total_assets':last_total_assets,\
                        'last_liabilities':last_liabilities,'debt_ratio':debt_ratio,'last_year':last_year,\
                        'critical_changes_in_last_3_years':critical_changes_in_last_3_years,\
                        'critical_changes_in_last_3_years_remarks':critical_changes_in_last_3_years_remarks,\
                        'core_staff_changes_in_last_2_years':core_staff_changes_in_last_2_years,\
                        'core_staff_changes_in_last_2_years_remarks':core_staff_changes_in_last_2_years_remarks,\
                        'core_research_shareholding_ratio':core_research_shareholding_ratio,\
                        'core_research_shareholding_ratio_remarks':core_research_shareholding_ratio_remarks,\
                        'actual_controller_shareholding_ratio':actual_controller_shareholding_ratio,\
                        'actual_controller_shareholding_ratio_remarks':actual_controller_shareholding_ratio_remarks,\
                        'actual_controller':actual_controller,'actual_controller_remarks':actual_controller_remarks,\
                        'employee_share_motivation':employee_share_motivation,\
                        'employee_share_motivation_remarks':employee_share_motivation_remarks,\
                        'shareholders_relationship':shareholders_relationship,\
                        'shareholders_relationship_remarks':shareholders_relationship_remarks,\
                        'department_structure':department_structure,\
                        'overlap_leader':overlap_leader,'overlap_leader_remarks':overlap_leader_remarks,\
                        'company_important_awards':company_important_awards,\
                        'company_important_awards_remarks':company_important_awards_remarks,\
                        'manager_important_awards':manager_important_awards,\
                        'manager_important_awards_remarks':manager_important_awards_remarks,\
                        'cooperate_financial_institutions_number':cooperate_financial_institutions_number,\
                        'cooperate_financial_institutions_number_remarks':cooperate_financial_institutions_number_remarks,\
                        'agent_sales_scale':agent_sales_scale,'agent_sales_scale_remarks':agent_sales_scale_remarks,\
                        'financial_institutions_invest_scale':financial_institutions_invest_scale,\
                        'financial_institutions_invest_scale_remarks':financial_institutions_invest_scale_remarks,\
                        'self_invest_scale':self_invest_scale,'self_sales_scale':self_sales_scale,\
                        'total_agent_sales_scale':total_agent_sales_scale,'total_manage_scale':total_manage_scale,\
                        'total_product_number':total_product_number,'product_manage_info':product_manage_info,\
                        'research_team_experience':research_team_experience,'research_team_background':research_team_background,\
                        'research_team_info':research_team_info,'senior_manager':senior_manager,}
        
        return manager_info
    

def get_manager_info_score(manager_info) -> dict:

    #公司概况得分
    #实缴资本得分
    contributed_capital_s = max(25-3*max((1000-manager_info['contributed_capital'])/100,0),0)

    #基协登记年限得分
    registered_years_s = 15-5*max(3-int(manager_info['registered_years']),0)

    #投顾资质得分
    if manager_info['advisor_qualification'] == "是": 
        advisor_qualification_s =  10    
    else:
        advisor_qualification_s =  0

    #协会会员得分
    if  manager_info['is_member'] == "是": 
        is_member_s =  10    
    else:
        is_member_s =  0
    
    #公司总人数得分
    staff_number_s = 40-2*max(20-manager_info['staff_number'],0)
        
    #公司概况总得分
    company_profile_total_score = contributed_capital_s+registered_years_s+advisor_qualification_s+is_member_s+staff_number_s
    
    #财务状况得分
    #主营业务收入得分
    max_main_income = max(manager_info['last_main_income'],manager_info['last_2_mean_main_income'])
    if max_main_income > 2000:
        main_income_s = 50
    elif max_main_income > 1600:
        main_income_s = 40
    elif max_main_income > 1200:
        main_income_s = 30
    elif max_main_income > 800:
        main_income_s = 20
    elif max_main_income > 500:
        main_income_s = 10
    else:
        main_income_s = 0        
        
    #净利润得分
    max_net_profit = max(manager_info['last_net_profit'],manager_info['last_2_mean_net_profit'])
    if max_net_profit > 1000:
        net_profit_s = 30
    elif max_net_profit > 600:
        net_profit_s = 20
    elif max_net_profit > 300:
        net_profit_s = 10
    else:
        net_profit_s = 0  
        
    #资产负债率得分
    if manager_info['debt_ratio'] < 0.4:
        debt_ratio_s = 20
    elif manager_info['debt_ratio']  < 0.6:
        debt_ratio_s = 10
    else:
        debt_ratio_s = 0  
     
    #财务状况总得分
    financial_indicator_total_score = main_income_s+net_profit_s+debt_ratio_s
    
    #治理结构得分
    #重要人员离职得分
    if manager_info['core_staff_changes_in_last_2_years']=="是":
        if manager_info['critical_changes_in_last_3_years']=="是":
            key_changes_s = 0
        else:
            key_changes_s = 20
    else:
        if manager_info['critical_changes_in_last_3_years']=="是":
            key_changes_s = 10
        else:
            key_changes_s = 30
    
    #负责人重叠得分
    overlap_leader_s = max(15-5*manager_info['overlap_leader'],0)
    
    #核心投研持股比例得分
    if manager_info['core_research_shareholding_ratio']<1/3:
        core_research_shareholding_ratio_s = 0
    elif manager_info['core_research_shareholding_ratio']<1/2:
        core_research_shareholding_ratio_s = 5
    elif manager_info['core_research_shareholding_ratio']<2/3:
        core_research_shareholding_ratio_s = 10
    else:
        core_research_shareholding_ratio_s = 15
    
    #实控人持股比例得分
    if manager_info['actual_controller_shareholding_ratio']<1/3:
        actual_controller_shareholding_ratio_s = 0
    elif manager_info['actual_controller_shareholding_ratio']<2/3:
        actual_controller_shareholding_ratio_s = 10
    else:
        actual_controller_shareholding_ratio_s = 20
        
    #员工持股激励得分
    if manager_info['employee_share_motivation']=="是":
        employee_share_motivation_s = 10
    else:
        employee_share_motivation_s = 0
        
    #控股股东关系得分
    if manager_info['shareholders_relationship']=="否":
        shareholders_relationship_s = 10
    else:
        shareholders_relationship_s = 0
        
    #治理结构总得分
    governance_structure_total_score = key_changes_s+overlap_leader_s+core_research_shareholding_ratio_s+\
                                       actual_controller_shareholding_ratio_s+employee_share_motivation_s+shareholders_relationship_s
                                          
    #机构合作与获奖情况得分
    #管理人获奖记录得分
    if manager_info['company_important_awards'] == 1:
        company_important_awards_s = 20
    elif manager_info['company_important_awards'] == 2:
        company_important_awards_s = 15
    elif manager_info['company_important_awards'] == 3:
        company_important_awards_s = 10
    elif manager_info['company_important_awards'] == 0:
        company_important_awards_s = 0
    else:
        print('管理人所获重要奖项输入有误！')
    
    #机构代销合作得分
    if manager_info['cooperate_financial_institutions_number']<1:
        cooperate_financial_institutions_number_s = 0
    elif manager_info['cooperate_financial_institutions_number']<2:
        cooperate_financial_institutions_number_s = 10
    elif manager_info['cooperate_financial_institutions_number']<3:
        cooperate_financial_institutions_number_s = 20
    elif manager_info['cooperate_financial_institutions_number']<4:
        cooperate_financial_institutions_number_s = 30
    elif manager_info['cooperate_financial_institutions_number']<5:
        cooperate_financial_institutions_number_s = 40
    else:
        cooperate_financial_institutions_number_s = 50
    
    #机构直投合作得分
    if manager_info['financial_institutions_invest_scale']<1:
        financial_institutions_invest_scale_s = 0
    elif manager_info['financial_institutions_invest_scale']<2:
        financial_institutions_invest_scale_s = 10
    elif manager_info['financial_institutions_invest_scale']<3:
        financial_institutions_invest_scale_s = 20
    else:
        financial_institutions_invest_scale_s = 30
    
    #机构合作与获奖情况总得分
    cooperation_awards_total_score = company_important_awards_s+cooperate_financial_institutions_number_s+\
                                     financial_institutions_invest_scale_s
    
    #投研团队得分
    #投研人数得分
    research_team_number_s = max(30-5*max(10-manager_info['research_team_number'],0),0)
    
    #投研人数比例得分
    if manager_info['research_team_ratio'] >= 0.5:
        research_team_ratio_s = 10
    elif manager_info['research_team_ratio'] < 0.5:
        research_team_ratio_s = 0
    else:
        print('投研人数比例计算有误！')

    #投资经理获奖记录得分
    if manager_info['manager_important_awards'] == 1:
        manager_important_awards_s = 30
    elif manager_info['manager_important_awards'] == 2:
        manager_important_awards_s = 15
    elif manager_info['manager_important_awards'] == 0:
        manager_important_awards_s = 0
    else:
        print('核心投资经理获奖情况输入有误！')
        
    #从业年限得分
    research_team_experience_score = []
    for i in range(len(manager_info['research_team_experience'])):
        if manager_info['research_team_experience'][i]< 1:
            research_team_experience_score.append(5)
        elif manager_info['research_team_experience'][i]< 3:
            research_team_experience_score.append(10)
        elif manager_info['research_team_experience'][i]< 5:
            research_team_experience_score.append(15)
        else:
            research_team_experience_score.append(20)
    research_team_experience_s = sum(research_team_experience_score)/len(research_team_experience_score)
    
    #从业背景得分
    research_team_background_score = [20 - 5*(i-1) for i in manager_info['research_team_background']]
    research_team_background_s = sum(research_team_background_score)/len(research_team_background_score)
    
    #投研团队总得分
    research_team_total_score = research_team_number_s+research_team_ratio_s+manager_important_awards_s+research_team_experience_s+\
                                research_team_background_s
    
    #管理规模得分
    if manager_info['total_manage_scale']<5:
        total_manage_scale_s = 0
    elif manager_info['total_manage_scale']<10:
        total_manage_scale_s = 40
    elif manager_info['total_manage_scale']<20:
        total_manage_scale_s = 60
    elif manager_info['total_manage_scale']<50:
        total_manage_scale_s = 80
    elif manager_info['total_manage_scale']<100:
        total_manage_scale_s = 90
    else:
        total_manage_scale_s = 100
    
    #管理人基本信息评分加权得分
    company_profile_w_score = company_profile_total_score*0.03
    financial_indicator_w_score = financial_indicator_total_score*0.03
    governance_structure_w_score = governance_structure_total_score*0.03
    cooperation_awards_w_score = cooperation_awards_total_score*0.08
    research_team_w_score = research_team_total_score*0.08
    manage_scale_w_score = total_manage_scale_s*0.15
    
    #管理人基本信息评分总得分、加权总得分
    manager_info_total_score = company_profile_total_score+financial_indicator_total_score+governance_structure_total_score+\
                               cooperation_awards_total_score+research_team_total_score+total_manage_scale_s
    
    manager_info_w_score = company_profile_w_score+financial_indicator_w_score+governance_structure_w_score+\
                           cooperation_awards_w_score+research_team_w_score+manage_scale_w_score
    
    
    #管理人基本信息评分  
    info_score = {'company_profile_score_1':contributed_capital_s,'company_profile_score_2':registered_years_s,\
                  'company_profile_score_3':advisor_qualification_s,'company_profile_score_4':is_member_s,\
                  'company_profile_score_5':staff_number_s,'company_profile_total_score':company_profile_total_score,\
                  'financial_indicator_score_1':main_income_s,'financial_indicator_score_2':net_profit_s,\
                  'financial_indicator_score_3':debt_ratio_s,'financial_indicator_total_score':financial_indicator_total_score,\
                  'governance_structure_score_1':key_changes_s,'governance_structure_score_2':overlap_leader_s,\
                  'governance_structure_score_3':core_research_shareholding_ratio_s,\
                  'governance_structure_score_4':actual_controller_shareholding_ratio_s,\
                  'governance_structure_score_5':employee_share_motivation_s,\
                  'governance_structure_score_6':shareholders_relationship_s,\
                  'governance_structure_total_score':governance_structure_total_score,\
                  'cooperation_awards_score_1':company_important_awards_s,\
                  'cooperation_awards_score_2':cooperate_financial_institutions_number_s,\
                  'cooperation_awards_score_3':financial_institutions_invest_scale_s,\
                  'cooperation_awards_total_score':cooperation_awards_total_score,\
                  'research_team_score_1':research_team_number_s,'research_team_score_2':manager_important_awards_s,\
                  'research_team_score_1_1':research_team_ratio_s,\
                  'research_team_score_3':research_team_experience_s,'research_team_score_4':research_team_background_s,\
                  'research_team_total_score':research_team_total_score,\
                  'manage_scale_score':total_manage_scale_s,\
                  'company_profile_w_score':company_profile_w_score,'financial_indicator_w_score':financial_indicator_w_score,\
                  'governance_structure_w_score':governance_structure_w_score,\
                  'cooperation_awards_w_score':cooperation_awards_w_score,\
                  'research_team_w_score':research_team_w_score,'manage_scale_w_score':manage_scale_w_score,\
                  'manager_info_total_score':manager_info_total_score,'manager_info_w_score':manager_info_w_score}
    return info_score